package com.example.note.dbtool;


import com.axdac.mixbind.sql.db.TableCreate;
import com.axdac.mixbind.sql.db.TableUpdate;

/**
 * Created by Administrator on 2018/2/26 0026.
 */

public class TableList {
    //创建笔记记录
    @TableCreate()
    @TableUpdate()
    public String create05 = "create table IF NOT EXISTS T_NOTE ( " +
            "ID integer  primary key AUTOINCREMENT," +
            "recordDate integer," +
            "title text," +
            "noteTagID integer," +
            "content text " +
            ");";

    //每个笔记的分类
    @TableCreate()
    @TableUpdate()
    public String create07 = "create table IF NOT EXISTS T_NOTE_TAG ( " +
            "ID integer  primary key AUTOINCREMENT," +
            "noteTag text " +
            ");";

}
